GO
 ALTER TABLE [dbo].[SHOP_FACTS]  WITH CHECK 
  ADD  CONSTRAINT [FK_SHOP_FACTS_ARTICLE_COLOR_LOOKUP] FOREIGN KEY([ARTICLE_CODE], [COLOR_CODE])
   REFERENCES [dbo].[ARTICLE_COLOR_LOOKUP] ([ARTICLE_CODE], [COLOR_CODE])

 ALTER TABLE [dbo].[SHOP_FACTS] 
  CHECK CONSTRAINT [FK_SHOP_FACTS_ARTICLE_COLOR_LOOKUP]


GO
 ALTER TABLE SHOP_FACTS
  ADD FOREIGN KEY (ARTICLE_CODE) 
   REFERENCES ARTICLE_LOOKUP(ARTICLE_CODE);


GO
 ALTER TABLE SHOP_FACTS
  ADD FOREIGN KEY (SHOP_CODE)
    REFERENCES OUTLET_LOOKUP(SHOP_CODE);


GO
 ALTER TABLE SHOP_FACTS
  ADD FOREIGN KEY (WEEK_KEY) 
   REFERENCES CALENDAR_YEAR_LOOKUP(WEEK_KEY);